﻿
-- ----------------------------------------------------------------------------------
--                         SystemMaint InYearGrades Grid
-- ----------------------------------------------------------------------------------
-- DELETE FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTINYEARGRADES' 
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTINYEARGRADES' AND ColumnName = 'InYearGradeID')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTINYEARGRADES', 'InYearGradeID', 'Grade ID', '', 'InYearGradeSetting.InYearGradeID  [sp_WebPlus_SystemMaint_Select] (INYEARGRADES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTINYEARGRADES' AND ColumnName = 'DefaultDescription')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTINYEARGRADES', 'DefaultDescription', 'Default Description', '', 'InYearGradeSetting.DefaultDescription  [sp_WebPlus_SystemMaint_Select] (INYEARGRADES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTINYEARGRADES' AND ColumnName = 'Description')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTINYEARGRADES', 'Description', 'Description', '', 'InYearGradeSetting.InYearGradeDescription  [sp_WebPlus_SystemMaint_Select] (INYEARGRADES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTINYEARGRADES' AND ColumnName = 'ShowByDefault')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTINYEARGRADES', 'ShowByDefault', 'Show By Default', '', 'InYearGradeSetting.ShowByDefault  [sp_WebPlus_SystemMaint_Select] (INYEARGRADES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTINYEARGRADES' AND ColumnName = 'IsEditable')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTINYEARGRADES', 'IsEditable', 'Is Editable', '', 'InYearGradeSetting.IsEditable  [sp_WebPlus_SystemMaint_Select] (INYEARGRADES)')
END


-- ----------------------------------------------------------------------------------
--                         SystemMaint EffortGrades Grid
-- ----------------------------------------------------------------------------------
-- DELETE FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTEFFORTGRADES' 
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTEFFORTGRADES' AND ColumnName = 'Description')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTEFFORTGRADES', 'Description', 'Description', '', 'InYearGradeEffort.Description  [sp_WebPlus_SystemMaint_Select] (INYEAREFFORTGRADES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTEFFORTGRADES' AND ColumnName = 'Obsolete')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTEFFORTGRADES', 'Obsolete', 'Obsolete', '', 'InYearGradeEffort.Obsolete  [sp_WebPlus_SystemMaint_Select] (INYEARGRADES)')
END



-- ----------------------------------------------------------------------------------
--                         SystemMaint PassFailGrades Grid
-- ----------------------------------------------------------------------------------
-- DELETE FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTPASSFAILGRADES' 
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTPASSFAILGRADES' AND ColumnName = 'Grade')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTPASSFAILGRADES', 'Grade', 'Grade', '', 'UnGradedQualifications_PointsGrades.Grade  [sp_WebPlus_SystemMaint_Select] (PASSFAILGRADES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTPASSFAILGRADES' AND ColumnName = 'Points')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTPASSFAILGRADES', 'Points', 'Points', '', 'UnGradedQualifications_PointsGrades.Points  [sp_WebPlus_SystemMaint_Select] (PASSFAILGRADES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTPASSFAILGRADES' AND ColumnName = 'GradeNo')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTPASSFAILGRADES', 'GradeNo', '<sup>1</sup> Grade No', '', 'UnGradedQualifications_PointsGrades.GradeNo  [sp_WebPlus_SystemMaint_Select] (PASSFAILGRADES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTPASSFAILGRADES' AND ColumnName = 'DefaultGrade')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTPASSFAILGRADES', 'DefaultGrade', 'Default<br>Target Grade', '', 'UnGradedQualifications_PointsGrades.DefaultGrade  [sp_WebPlus_SystemMaint_Select] (PASSFAILGRADES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTPASSFAILGRADES' AND ColumnName = 'InflatedGrade')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTPASSFAILGRADES', 'InflatedGrade', 'Default<br>Inflated Grade', '', 'UnGradedQualifications_PointsGrades.InflatedGrade  [sp_WebPlus_SystemMaint_Select] (PASSFAILGRADES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTPASSFAILGRADES' AND ColumnName = 'ViewOnWebsite')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTPASSFAILGRADES', 'ViewOnWebsite', 'View on<br>Website', '', 'UnGradedQualifications_PointsGrades.ViewOnWebsite  [sp_WebPlus_SystemMaint_Select] (PASSFAILGRADES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTPASSFAILGRADES' AND ColumnName = 'Obsolete')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTPASSFAILGRADES', 'Obsolete', 'Obsolete', '', 'UnGradedQualifications_PointsGrades.Obsolete  [sp_WebPlus_SystemMaint_Select] (PASSFAILGRADES)')
END



-- ----------------------------------------------------------------------------------
--                         SystemMaint NoGradeGrades Grid
-- ----------------------------------------------------------------------------------
-- DELETE FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTNOGRADEGRADES' 
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTNOGRADEGRADES' AND ColumnName = 'Grade')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTNOGRADEGRADES', 'Grade', 'Grade', '', 'GradingScheme_NoGrade.Grade  [sp_WebPlus_SystemMaint_Select] (NOGRADEGRADES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTNOGRADEGRADES' AND ColumnName = 'Description')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTNOGRADEGRADES', 'Description', 'Description', '', 'GradingScheme_NoGrade.Description  [sp_WebPlus_SystemMaint_Select] (NOGRADEGRADES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTNOGRADEGRADES' AND ColumnName = 'Points')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTNOGRADEGRADES', 'Points', 'Points', '', 'GradingScheme_NoGrade.Points  [sp_WebPlus_SystemMaint_Select] (NOGRADEGRADES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTNOGRADEGRADES' AND ColumnName = 'GradeNo')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTNOGRADEGRADES', 'GradeNo', '<sup>1</sup> Grade No', '', 'GradingScheme_NoGrade.GradeNo  [sp_WebPlus_SystemMaint_Select] (NOGRADEGRADES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTNOGRADEGRADES' AND ColumnName = 'DefaultGrade')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTNOGRADEGRADES', 'DefaultGrade', 'Default<br>Target Grade', '', 'GradingScheme_NoGrade.DefaultTarget  [sp_WebPlus_SystemMaint_Select] (NOGRADEGRADES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTNOGRADEGRADES' AND ColumnName = 'Obsolete')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTNOGRADEGRADES', 'Obsolete', 'Obsolete', '', 'GradingScheme_NoGrade.Obsolete  [sp_WebPlus_SystemMaint_Select] (NOGRADEGRADES)')
END



-- ----------------------------------------------------------------------------------
--                         SystemMaint SettingValues Grid
-- ----------------------------------------------------------------------------------
-- DELETE FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTSETTINGVALUES' 
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTSETTINGVALUES' AND ColumnName = 'SettingName')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTSETTINGVALUES', 'SettingName', 'Setting Name', '', 'SystemSettingValue.SystemSettingName  [sp_WebPlus_SystemMaint_Select] (SETTINGVALUES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTSETTINGVALUES' AND ColumnName = 'SettingDefaultValue')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTSETTINGVALUES', 'SettingDefaultValue', 'Default Value', '', 'SystemSettingValue.DefaultValue  [sp_WebPlus_SystemMaint_Select] (SETTINGVALUES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTSETTINGVALUES' AND ColumnName = 'SettingValue')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTSETTINGVALUES', 'SettingValue', 'Setting Value', '', 'SystemSettingValue.SystemSettingValue  [sp_WebPlus_SystemMaint_Select] (SETTINGVALUES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTSETTINGVALUES' AND ColumnName = 'SettingDescription')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTSETTINGVALUES', 'SettingDescription', 'Setting Description', '', 'SystemSettingValue.SystemSettingDescription  [sp_WebPlus_SystemMaint_Select] (SETTINGVALUES)')
END



-- ----------------------------------------------------------------------------------
--                         SystemMaint SettingFlags Grid
-- ----------------------------------------------------------------------------------
-- DELETE FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTSETTINGFLAGS' 
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTSETTINGFLAGS' AND ColumnName = 'SettingName')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTSETTINGFLAGS', 'SettingName', 'Setting Name', '', 'SystemSettingFlag.SettingName  [sp_WebPlus_SystemMaint_Select] (SETTINGFLAGS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTSETTINGFLAGS' AND ColumnName = 'SettingCategory')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTSETTINGFLAGS', 'SettingCategory', 'Category', '', 'SystemSettingFlag.Category  [sp_WebPlus_SystemMaint_Select] (SETTINGFLAGS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTSETTINGFLAGS' AND ColumnName = 'SettingFlagValue')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTSETTINGFLAGS', 'SettingFlagValue', 'Value', '', 'SystemSettingFlag.Value  [sp_WebPlus_SystemMaint_Select] (SETTINGFLAGS)')
END



-- ----------------------------------------------------------------------------------
--                         SystemMaint UserDefinedFields Grid
-- ----------------------------------------------------------------------------------
-- DELETE FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTUSERDEFINEDFIELDS' 
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTUSERDEFINEDFIELDS' AND ColumnName = 'TableName')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTUSERDEFINEDFIELDS', 'TableName', 'Table Name', '', 'UserDefinedFields.TableName  [sp_WebPlus_SystemMaint_Select] (USERDEFINEDFIELDS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTUSERDEFINEDFIELDS' AND ColumnName = 'SystemName')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTUSERDEFINEDFIELDS', 'SystemName', 'System Field Name', '', 'UserDefinedFields.SystemName  [sp_WebPlus_SystemMaint_Select] (USERDEFINEDFIELDS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SYSTEMMAINTUSERDEFINEDFIELDS' AND ColumnName = 'UserDefinedName')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SYSTEMMAINTUSERDEFINEDFIELDS', 'UserDefinedName', 'User Defined Name', '', 'UserDefinedFields.UserDefinedName  [sp_WebPlus_SystemMaint_Select] (USERDEFINEDFIELDS)')
END



-- ----------------------------------------------------------------------------------
--                         New column in MARKBOOKMAINTELEMENT Grid
-- ----------------------------------------------------------------------------------
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTELEMENT' AND ColumnName = 'AutoCompleteStatus')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTELEMENT', 'AutoCompleteStatus', 'AutoComplete', 'Indicates the AutoComplete Status for this Element', 'Calculated: fn_GetAutocompleteStatus()  [sp_WebPlus_MarkBookMaint_Select] (COURSEELEMENTS or CHILDELEMENTS)')
END


-- ----------------------------------------------------------------------------------
--                         Delta Maint Categories Grid
-- ----------------------------------------------------------------------------------
-- DELETE FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTCATEGORIES' 
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTCATEGORIES' AND ColumnName = 'SystemName')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTCATEGORIES', 'SystemName', 'System Name', '', 'Delta_Category.SystemName  [sp_WebPlus_SystemMaint_Select] (DELTACATEGORIES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTCATEGORIES' AND ColumnName = 'DisplayName')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTCATEGORIES', 'DisplayName', 'Display Name', '', 'Delta_Category.DisplayName  [sp_WebPlus_SystemMaint_Select] (DELTACATEGORIES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTCATEGORIES' AND ColumnName = 'ShortDisplayName')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTCATEGORIES', 'ShortDisplayName', 'Short Display Name', '', 'Delta_Category.ShortDisplayName  [sp_WebPlus_SystemMaint_Select] (DELTACATEGORIES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTCATEGORIES' AND ColumnName = 'Weighting')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTCATEGORIES', 'Weighting', 'Weighting', '', 'Delta_Category.Weighting  [sp_WebPlus_SystemMaint_Select] (DELTACATEGORIES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTCATEGORIES' AND ColumnName = 'TaperDays')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTCATEGORIES', 'TaperDays', 'Taper Days', '', 'Delta_Category.TaperDays  [sp_WebPlus_SystemMaint_Select] (DELTACATEGORIES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTCATEGORIES' AND ColumnName = 'IsActive')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTCATEGORIES', 'IsActive', 'Active', '', 'Delta_Category.IsActive  [sp_WebPlus_SystemMaint_Select] (DELTACATEGORIES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTCATEGORIES' AND ColumnName = 'IsFixed')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTCATEGORIES', 'IsFixed', 'Fixed', 'True indicates a System Category, False means the Category is UserDefined', 'Delta_Category.IsFixed  [sp_WebPlus_SystemMaint_Select] (DELTACATEGORIES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTCATEGORIES' AND ColumnName = 'IsExternalDataSource')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTCATEGORIES', 'IsExternalDataSource', '<sup>1</sup> External DataSource', '', 'Delta_Category.IsExternalDataSource  [sp_WebPlus_SystemMaint_Select] (DELTACATEGORIES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTCATEGORIES' AND ColumnName = 'ContributeToStudentScore')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTCATEGORIES', 'ContributeToStudentScore', '<sup>2</sup> Contribute to StudentScore', '', 'Delta_Category.ContributeToStudentScore  [sp_WebPlus_SystemMaint_Select] (DELTACATEGORIES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTCATEGORIES' AND ColumnName = 'OrderBy')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTCATEGORIES', 'OrderBy', 'Order', '', 'Delta_Category.OrderBy  [sp_WebPlus_SystemMaint_Select] (DELTACATEGORIES)')
END



-- ----------------------------------------------------------------------------------
--                         Delta Maint CategoryBanding Grid
-- ----------------------------------------------------------------------------------
-- DELETE FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTCATEGORYBANDINGS' 
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTCATEGORYBANDINGS' AND ColumnName = 'CategoryName')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTCATEGORYBANDINGS', 'CategoryName', 'Category Name', '', 'Delta_Category_Banding.DeltaCategoryID -> Delta_Category.DisplayName  [sp_WebPlus_SystemMaint_Select] (DELTACATEGORYBANDINGS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTCATEGORYBANDINGS' AND ColumnName = 'DeltaScore')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTCATEGORYBANDINGS', 'DeltaScore', 'Delta Score', '', 'Delta_Category_Banding.Score  [sp_WebPlus_SystemMaint_Select] (DELTACATEGORYBANDINGS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTCATEGORYBANDINGS' AND ColumnName = 'DeltaScoreName')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTCATEGORYBANDINGS', 'DeltaScoreName', 'Delta Score Name', '', 'Delta_Category_Banding.DeltaScoreName  [sp_WebPlus_SystemMaint_Select] (DELTACATEGORYBANDINGS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTCATEGORYBANDINGS' AND ColumnName = 'Min')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTCATEGORYBANDINGS', 'Min', 'Min Value', '', 'Delta_Category_Banding.Min  [sp_WebPlus_SystemMaint_Select] (DELTACATEGORYBANDINGS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTCATEGORYBANDINGS' AND ColumnName = 'Max')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTCATEGORYBANDINGS', 'Max', 'Max Value', '', 'Delta_Category_Banding.Max  [sp_WebPlus_SystemMaint_Select] (DELTACATEGORYBANDINGS)')
END



-- ----------------------------------------------------------------------------------
--                         Delta Maint StartDates Grid
-- ----------------------------------------------------------------------------------
-- DELETE FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTSTARTDATES' 
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTSTARTDATES' AND ColumnName = 'AcademicYearID')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTSTARTDATES', 'AcademicYearID', 'Academic Year ID', '', 'Delta_AcYrWeek1StartDate.AcademicYearID  [sp_WebPlus_SystemMaint_Select] (DELTASTARTDATES)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTSTARTDATES' AND ColumnName = 'StartDate')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTSTARTDATES', 'StartDate', 'Start Date', '', 'Delta_AcYrWeek1StartDate.StartDate  [sp_WebPlus_SystemMaint_Select] (DELTASTARTDATES)')
END



-- ----------------------------------------------------------------------------------
--                         Delta Maint InfoFlags Grid
-- ----------------------------------------------------------------------------------
-- DELETE FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTINFOFLAGS' 
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTINFOFLAGS' AND ColumnName = 'SystemName')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTINFOFLAGS', 'SystemName', 'System Name', '', 'Delta_Student_InformationFlag_Definition.SystemName  [sp_WebPlus_DeltaMaint_Select] (DELTASTUDENTINFOFLAGS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTINFOFLAGS' AND ColumnName = 'FieldType')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTINFOFLAGS', 'FieldType', 'Field Type', '', 'Fixed Values based on ID (1-12 Bit) and (13-18 Varchar)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTINFOFLAGS' AND ColumnName = 'DisplayName')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTINFOFLAGS', 'DisplayName', 'Display Name', '', 'Delta_Student_InformationFlag_Definition.DisplayName  [sp_WebPlus_DeltaMaint_Select] (DELTASTUDENTINFOFLAGS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTINFOFLAGS' AND ColumnName = 'ShortDisplayName')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTINFOFLAGS', 'ShortDisplayName', 'Short Display Name', '', 'Delta_Student_InformationFlag_Definition.ShortDisplayName  [sp_WebPlus_DeltaMaint_Select] (DELTASTUDENTINFOFLAGS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'DELTAMAINTINFOFLAGS' AND ColumnName = 'IsActive')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('DELTAMAINTINFOFLAGS', 'IsActive', 'Active', '', 'Delta_Student_InformationFlag_Definition.IsActive  [sp_WebPlus_DeltaMaint_Select] (DELTASTUDENTINFOFLAGS)')
END



